﻿-- =============================================  
-- Author:  <Author,,Name>  
-- Create date: <Create Date,,>  
-- Description: <Description,,>  
-- =============================================  
alter PROCEDURE [dbo].[Get_LookUpByCode]  
 @Code varchar(250)  
AS  
BEGIN  
 select * from tblLookup l where l.LookUpCode=@Code  and l.Active=1
END  

Go
 
CREATE PROCEDURE SpGetCommercialByName  
  @Name varchar(250)  
AS  
BEGIN  
 select * from Commercial c  
where c.Name like @Name  
END  
  